
import pandas as pd
import time

#每周数据列表，从"problem_handle"程序生成
ProblemCount = [1, 42, 6, 75, 2, 84, 3, 58]

#获取当前周
kw = "KW" + time.strftime("%U",time.localtime())
print(kw)

df = pd.read_excel("D:\\5.大众品牌周报\\输出材料\\问题管理数据.xlsx")
print(df)

df.loc[0:7,kw] = ProblemCount
print(df)


